<?php
$localhost = 'localhost';
$usernamesql = 'root';
$passwordsql = 'root';
$conn = mysqli_connect($localhost, $usernamesql, $passwordsql);
//创建数据库flower
$create="create database  if not exists bigmelon default character set utf8 default collate utf8_general_ci";
$res=mysqli_query($conn,$create);
//应用数据库
$query='use bigmelon';
//创建列flowers
mysqli_query($conn,$query);
$query="create table if not exists melon(
    tel varchar(30) not null,
    username varchar(50) not null,
    password varchar(50) not null,
    tel_active varchar(4) ,
    id int not null auto_increment,
    primary key(id)
)
engine=innodb";
mysqli_query($conn,$query);
?>
